-- ****** Object: Table ASM_GEP.GEP_DATIM01 Script Date: 17/12/2012 23:23:44 ******
CREATE TABLE "GEP_DATIM01" (
  "DM01_COD_PRATICA" NUMBER NOT NULL,
  "DM01_LETRECL_AF1" NUMBER(22,0) NULL,
  "DM01_LETRECL_AF2" NUMBER(22,0) NULL,
  "DM01_LETRECL_AF3" NUMBER(22,0) NULL,
  "DM01_LETRECL_RF1" NUMBER(22,0) NULL,
  "DM01_LETRECL_RF2" NUMBER(22,0) NULL,
  "DM01_LETRECL_RF3" NUMBER(22,0) NULL,
  "DM01_LETRECL_PF1" NUMBER(22,0) NULL,
  "DM01_LETRECL_PF2" NUMBER(22,0) NULL,
  "DM01_LETRECL_RP3" NUMBER(22,0) NULL,
  "DM01_DT_LET_RECL" DATE NULL,
  "DM01_TIP_LET_RECL" VARCHAR2(1 BYTE) NULL,
  "DM01_NEW_RECL" VARCHAR2(2 BYTE) NULL,
  "DM01_CODRECLAMO" VARCHAR2(10 BYTE) NULL,
  "DM01_LETCLI_AF1" NUMBER(22,0) NULL,
  "DM01_LETCLI_AF2" NUMBER(22,0) NULL,
  "DM01_LETCLI_AF3" NUMBER(22,0) NULL,
  "DM01_LETCLI_RF1" NUMBER(22,0) NULL,
  "DM01_LETCLI_RF2" NUMBER(22,0) NULL,
  "DM01_LETCLI_RF3" NUMBER(22,0) NULL,
  "DM01_LETCLI_PF1" NUMBER(22,0) NULL,
  "DM01_LETCLI_PF2" NUMBER(22,0) NULL,
  "DM01_LETCLI_RP3" NUMBER(22,0) NULL,
  "DM01_DT_LET_CLI" DATE NULL)
/
CREATE UNIQUE INDEX "GEP_DATIM01_PK"
  ON "GEP_DATIM01" ( 
    "DM01_COD_PRATICA")
/
ALTER TABLE "GEP_DATIM01" ADD ( 
  CONSTRAINT "GEP_DATIM01_PK" 
    PRIMARY KEY ( "DM01_COD_PRATICA") 
    USING INDEX "GEP_DATIM01_PK" 
    ENABLE 
    VALIDATE )
/
